USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[ObjectsInsert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.ObjectsInsert
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 08/29/08
-- Description:	Objects Table Insert
-- =============================================
CREATE PROCEDURE ObjectsInsert

            @ObjectId int,
            @ObjectShortName varchar(50),
            @ObjectLongName varchar(100)
	

AS
BEGIN

INSERT INTO [Objects]
           ([ObjectId]
           ,[ObjectShortName]
           ,[ObjectLongName])
     VALUES
           (@ObjectId,
            @ObjectShortName,
            @ObjectLongName)
END
GO
